<?php
    include './base.php';
    $address = $_GET["address"];
    $sql = "select * from room inner join roomtype where room.roomType = roomtype.rtId and roomAddress LIKE '$address%'";
    $res = mysql_query($sql);
    $arr = array();
    while($row = mysql_fetch_assoc($res)){
        array_push($arr,$row);
    }
    print_r(json_encode($arr));
?>